For the Source Accounts that were loaded, assume a single Account Group is desired to reconcile all cash balances in one reconciliation. First, the Account Group is created, and the Account and Local currency types are selected as part of that creation. For this example, The Account Group Account currency is CAD and the Account Group Local currency is GBP.
-
Using the same FX rates listed above, OneStream will automatically translate the Child (i.e. Source) currency balances to the Group currency balances.
-
The translated balances are then aggregated for each currency level and are the reconciling balances for the Account Group.
-
10,000 EUR * 1.52 = 15,200 CAD**
-
9,000 GBP * 1.74 = 15,660 CAD
-
15,000 CAD * 1.00 = 15,000 CAD
-
15,200 CAD * 1.00 = 15,200 CAD
-
10,000 EUR * 0.88 = 8,800 GBP**
-
10,900 USD * 1.00 = 10,900 USD
-
11,000 USD * 1.00 = 11,000 USD
**These examples reflect the use of OneStream calculated inverse rates and is for clarification purposes only.
